|
Install phpPgAdmin
2015/01/15 |
|
Install phpPgAdmin to operate PostgreSQL on web browser from Clients.
Web is required for it.
|
|
| [1] | Install phpPgAdmin. |
|
[root@www ~]#
vi /etc/phpPgAdmin/config.inc.php # line 18: add $conf['servers'][0]['host'] = ' localhost ';
# line 94: add $conf['owned_only'] = true ;
[root@www ~]#
vi /var/lib/pgsql/data/pg_hba.conf # line 70: add IP address you allow host all all 127.0.0.1/32 ident sameuser host
all all 10.0.0.0/24 ident sameuser
[root@www ~]#
vi /etc/httpd/conf.d/phpPgAdmin.conf # line 11: add IP address you allow Allow from 127.0.0.1 10.0.0.0/24 /etc/rc.d/init.d/httpd reload Reloading httpd: [ OK ] |
| [2] | Access to the "http://(hostname or IP addressÃ¥ÂÂ)/phpPgAdmin" and click "PostgreSQL" on the left menu. |
|
| [3] | Autenticate a user and password which is in PostgreSQL. |
|
| [4] | Just logined. You can operate PostgreSQL on here. |
|